Operational activities of datacenter, Team management & day to day activities of datacenter, maintain Iaas in satisfactory mode. Oracle Patching, Up-gradation, ETL, Dell TL/4000 Library With Oracle Secure Backup Configuring, Linux/Window Administration Server for oracle, Scheduling Job Cron tab, Oracle Scheduler, Data Moving, Backup (Hot , cold, Logical) Recovery (Hot backup, Logical Baclup, Cold Backup) Standby & Disaster Recovery, Physical Standby (Maximum Performance Mode ) , Script Writing (PL-SQL packages, Procedure, function,) Report writing ( With heavy join and Inner query) Installation, Administration, Configuration & Maintenance Oracle Database 10gR2, 11gR2 ie Linux Red Hat 5.3 and Window Server. Performance Tuning ie Collect/Calculate Histogram and Binary Hight Index or Table, Checking ratio Hit, Missed into SGA. Use Advisory Frame, Tune PGA and Other Parameter. Explain Plan & SQL trace Utility, Query to Monitor Shared Pool. Genrate/Analyze AWR, STATPACK, ADDM, ASH Reports and Other V, X and DBA views.

Currently working as Assistant Director IT at Punjab Social Security, heading the technical operation in IT department. Following are some important responsibilities/ IT projects.
 Making sure timely and speedily delivery of IT services to internal (7500 employees of PESSI) and external stakeholders (One Million secured worker along with their 20 Million dependents and sixty thousands industrial and commercial establishment which are registered with PESSI) of organization.
 Implementation of HMIS at 14 PESSI Hospital and 270 Medical/emergency center across Punjab.
 Implementation of PACS (Picture Archiving and Communication System) at 14 PESSI
Hospital and 270 Medical/emergency center across Punjab.
Implementation of ERP for collection of Social Security (SS) Contribution and health care service delivery.
 Implementing integrated inventory control system for central medical store department
(CMSD) of PESSI.
Heading Vendor management activities for IT Projects. PESSI has long list of vendors including DELL, Microsoft and Oracle etc.
Supervising the operations of data center.

Oracle Patching, Up-gradation, ETL, Dell TL/4000 Library With Oracle Secure Backup Configuring, Linux/Window Administration Server for oracle, Scheduling Job Cron tab, Oracle Scheduler, Data Moving, Backup (Hot , cold, Logical) Recovery (Hot backup, Logical Baclup, Cold Backup) Standby & Disaster Recovery, Physical Standby (Maximum Performance Mode ) , Script Writing (PL-SQL packages, Procedure, function,) Report writing ( With heavy join and Inner query) Installation, Administration, Configuration & Maintenance Oracle Database 10gR2, 11gR2 i:e Linux Red Hat 5.3 and Window Server. Performance Tuning i:e Collect/Calculate Histogram and Binary Hight Index or Table, Checking ratio Hit, Missed into SGA. Use Advisory Frame, Tune PGA and Other Parameter. Explain Plan & SQL trace Utility, Query to Monitor Shared Pool. Genrate/Analyze AWR, STATPACK, ADDM, ASH Reports and Other V$, X$ and DBA views.

Script Writing (PL-SQL packages, Procedure, function,) Report writing ( With heavy join and Inner query) Script Writing (PL-SQL packages, Procedure, function,) Report writing ( With heavy join and Inner query)